














USE character

select * from charinfo --101052






SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE dbo.usp_blreo_get
	@GID INT
AS
	SET NOCOUNT ON
	
	SELECT AID, CharName FROM charinfo WHERE GID = @GID

	SET NOCOUNT OFF
GO

SET QUOTED_IDENTIFIER OFF 
GO

SET ANSI_NULLS ON 
GO


EXEC usp_blreo_get 101052